CREATE procedure [dbo].[BAEEventSetupAddRegistrant] @EventCode varchar(15),
      @pageMessage varchar(255),
      @FirstName varchar(25) ,
      @FirstNameEnabled bit ,
      @FirstNameRequired bit ,
      @MiddleInitial varchar(25) ,
      @MiddleInitialEnabled bit ,
      @MiddleInitialRequired bit ,
      @LastName varchar(25) ,
      @LastNameEnabled bit ,
      @LastNameRequired bit ,
      @Address varchar(25) ,
      @AddressEnabled bit ,
      @AddressRequired bit ,
      @City varchar(25) ,
      @CityEnabled bit ,
      @CityRequired bit ,
      @State varchar(25) ,
      @StateEnabled bit ,
      @StateRequired bit,
      @PostalCode varchar(25),
      @PostalCodeEnabled bit,
      @PostalCodeRequired bit,
      @Phone varchar(25) ,
      @PhoneEnabled bit ,
      @PhoneRequired bit,
      @Email varchar(25),
      @EmailEnabled bit,
      @EmailRequired bit,
      @Country varchar(25),
      @CountryEnabled bit,
      @CountryRequired bit as

SELECT * FROM EventSetupRegistrant
      WHERE EventCode = @EventCode;
      IF(@@RowCount > 0)
            BEGIN
                  UPDATE EventSetupRegistrant
                        SET RegistrantPageMessage = @pageMessage, FirstName = @FirstName, FirstNameEnabled = @FirstNameEnabled, FirstNameRequired = @FirstNameRequired, MiddleInitial = @MiddleInitial, MiddleInitialEnabled = @MiddleInitialEnabled, MiddleInitialRequired = @MiddleInitialRequired, LastName = @LastName, LastNameEnabled = @LastNameEnabled, LastNameRequired = @LastNameRequired, Address = @Address, AddressEnabled = @AddressEnabled, AddressRequired = @AddressRequired, City = @City, CityEnabled = @CityEnabled, CityRequired = @CityRequired, StateProvince = @State, StateEnabled = @StateEnabled, StateRequired = @StateRequired, PostalCode =@PostalCode,  PostalCodeEnabled = @PostalCodeEnabled, PostalCodeRequired = @PostalCodeRequired, Phone = @Phone, PhoneEnabled = @PhoneEnabled, PhoneRequired = @PhoneRequired, Email = @Email, EmailEnabled = @EmailEnabled, EmailRequired = @EmailRequired, Country = @Country, CountryEnabled = @CountryEnabled, CountryRequired = @CountryRequired
                  WHERE EventCode = @EventCode;
            END
      ELSE
            BEGIN
                  INSERT INTO EventSetupRegistrant
                  VALUES(@EventCode,@pageMessage, @FirstName, @FirstNameEnabled, @FirstNameRequired, @MiddleInitial, @MiddleInitialEnabled,@MiddleInitialRequired, @LastName, @LastNameEnabled, @LastNameRequired, @Address, @AddressEnabled,@AddressRequired, @City, @CityEnabled, @CityRequired, @State, @StateEnabled, @StateRequired, @PostalCode,@PostalCodeEnabled , @PostalCodeRequired, @Phone, @PhoneEnabled, @PhoneRequired, @Email, @EmailEnabled,    @EmailRequired, @Country, @CountryEnabled, @CountryRequired);
      END

GO